if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_UpdateProduct]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_UpdateProduct]
GO
CREATE PROC sp_UpdateProduct
	@id			int,
	@cateID		int,
	@proName	nvarchar(100),
	@image		varchar(200),
	@des		nvarchar(2000),
	@price		float
AS
BEGIN
	UPDATE Product
		SET
			CategoryID = @cateID,
			ProductName = @proName, 
			Image = @image, 
			Description = @des, 
			Price = @price
		WHERE
			ID = @id
END